EMT Practice Test

1. Question Content...

---

Question1: You are building a new calculation view, A, Which includes a projection node that refers to another calculation view, B. WHY would you use the extract semantics feature?
Please choose the correct answer.
Response:

Question2: In which of the following circumstances do you use graph processing?
There are 2 correct answers to this question.
Response:

Question3: Which business intelligence tool can publish storyboards?
Please choose the correct answer.
Response:

Question4: Your calculation view includes the following SALES_ORDER_ID and ITEM as attributes, and QUANTITY and PRICE as measures. You create a calculated column, ITEM_TOTAL, with the formula QUANTITY*PRICE.
In which node do you define the calculation to display the correct aggregated result?
Please choose the correct answer.
Response:

Question5: Identify the join that checks the From and To column on the left table.
Please choose the correct answer.
Response:

Question6: What performance technique should you implement to improve join performance?
Please choose the correct answer.
Response:

Question7: In your calculation view, you need to define a custom data source using SQL Script. In which object do you write your SQL Script?
Please choose the correct answer.
Response:

Question8: One SQL analytic privilege authorizes you to view data for Europe and the USA in the sales calculation view, and another one authorizes you to view data for Asia and the USA in the income calculation view.
The income view uses the sales view as a data source.
Both calculation views check SQL analytic privileges.

What data can you visualize when consuming the income calculation view?
Please choose the correct answer.
Response:

Question9: What do you need to do after creating a new project with an HDB module?
Please choose the correct answer.
Response:

Question10: What predicate do you use for fuzzy text search in the WHERE clause of a SQL statement?
Please choose the correct answer.
Response:

Question11: What must be installed for PAL to work?
Please choose the correct answer.
Response:

Question12: In an XSA/HDI environment, which of the following is used for source version control of calculation views?
Please choose the correct answer.
Response:

Question13: Which of the following techniques can you use to improve the performance of calculation views?
There are 2 correct answers to this question.
Response:

Question14: Using a calculation view containing the projections shown in the graphic, how would you identify which companies sold products in January 2018 AND February 2018?
Please choose the correct answer.
Projection Sales January 2018
Projection Sales February 2018
Company Product Quantity Company Product Quantity

Response:

Question15: How can the system database administrator disable tenant database functionalities?
Please choose the correct answer.
Response:

Question16: What does SQL script provide to extend standard SQL?
There are 2 correct answers to this question.
Response:

Question17: How does SAP S/4HANA embedded analytics differ from SAP HANA Live?
There are 2 correct answers to this question.
Response:

Question18: On a weekly basis, you need to extract and transform data from multiple sources such as SAP ERP Microsoft Excel and Apache Hadoop and load the data into SAP HANA.
Which tools can you use?
There are 2 correct answers to this question.
Response:

Question19: How many tiers do you usually find in an SAP HANA application?
There are 2 correct answers to this question.
Response:

Question20: What are the database query languages used by SAP HANA?
There are 2 correct answers to this question.
Response:

Question21: Your calculation view presents employee names which must only be seen by managers. Which steps are required to implement this?
There are 2 correct answers to this question.
Response:

Question22: Using the table in the diagram, you need to create a cube calculation view. What is the simplest approach to create the output form the screenshot?
Please choose the correct answer.
Table A Output A
Year Value 2014 2015 2016
2014 100 300 500 200
2014 200
2015 100
2015 100
2015 200
2015 100
2015 200
Response:

Question23: What is a multistore table?
Please choose the correct answer.
Response:

Question24: You're creating a currency conversion. What options do you have for the Target Currency field?
There are 3 correct answers to this question.
Response:

Question25: What are the currency conversion functionalities supported by SAP HANA?
There are 3 correct answers to this question.
Response:

Question26: In a calculation view, what should you consider when you create an input parameter that derives its value from a user-defined function?
There are 2 correct answers to this question.
Response:

Question27: You want to star schema using calculating view. The measure are based on columns from two transaction table dimension calculation views provide the attributes.
What is the correct approach?
Please choose the correct answer.
Response:

Question28: How would you most likely represent the location of an ATM in a visual application that uses SAP HANA spatial processing?
Please choose the correct answer.
Response:

Question29: Which business intelligence tool does NOT use BICS connectivity to SAP HANA?
There are 2 correct answers to this question.
Response:

Question30: Why do you create a multistory table?
Please choose the correct answer.
Response:

Question31: What performance technique should you implement to improve the performance of SAP HANA information views?
Please choose the correct answer.
Response:

Question32: Identify the features and benefits of a calculation view.
There are 3 correct answers to this question.
Response:

Question33: You have Model B that is based on Model A.
You have successfully built both models.
You delete Model B.
What happens during the build?
There are 2 correct answers to this question.
Response:

Question34: In your calculation view, you CANNOT enable a hierarchy for time dependency. What could be the reason for this?
Response:

Question35: You have a cube calculation view that consumes a dimension view. You suspect some dimension columns have been renamed in the cube calculation view.
Which function of SAP Web IDE for SAP HANA do you use to check where the output columns originate from?
Please choose the correct answer.
Response:

Question36: You have Model B that is based on Model A.
You have NOT built any of the models yet.
You delete Model A.
What happens during the build?
There are 2 correct answers to this question.
Response:

Question37: In a calculation view, where can you use SQL?
There are 3 correct answers to this question.
Response:

Question38: What technique is used to convert record updates into insert statements in the delta buffer?
Please choose the correct answer.
Response:

Question39: You use parallelism to calculate a year-to-date value quickly, and you elimi- nate a table from the database. What are some of the implications of this action?
There are 3 correct answers to this question.
Response:

Question40: In which of the following scenarios would you benefit from enabling table portioning in SAP HANA?
Please choose the correct answer.
Response:

Question41: In SAP HANA Series Data processing, what is the definition of a profile?
Please choose the correct answer.
Response:

Question42: What conditions must be met before you can implement time dependency on a hierarchy in a calculation view?
There are 2 correct answers to this question.
Response:

Question43: What do you use in a SQL query to sort fuzzy text search results by relevance?
Please choose the correct answer.
Response:

Question44: Which recent trends have triggered the need for a next generation data processing platform?
There are 3 correct answers to this question.
Response:

Question45: You have a discussion with board members of a company. They want your recommendation on a business intelligence tool that they can use on their Apple iPad to display KPI dashboards. They also want a WYSIWYG design environment that allows scripting, should it be required.
Which tool do you recommend?
Please choose the correct answer.
Response:

Question46: What are the advantages of columnar storage?
There are 2 correct answers to this question.
Response:

Question47: How can you define a variable that presents its value help hierarchically?
There are 2 correct answers to this question
Response:

Question48: You're selling books that have been translated into various languages. What join type should you use?
Please choose the correct answer.
Response:

Question49: You need a business intelligence tool that is Microsoft Excel-based and can use parent-child hierarchies.
Which tool do you use?
Please choose the correct answer.
Response:

Question50: Which of the following are results of deploying SAP HANA as a distributed (scale-out) solution?
There are 2 correct answers to this question.
Response:

Question51: The company asks you to get data from IoT sensors. Which SAP tools could you use?
There are 3 correct answers to this question.
Response:

Question52: Which of the following benefits characterize the use of a design time filter?
There are 3 correct answers to this question.
Response:

Question53: Which recent technology innovations have triggered the opportunity to build a next generation data processing platform?
There are 2 correct answers to this question.
Response:

Question54: You have a table with two columns, CUSTOMER NAME and COUNTRY NAME, In which Italian customers are stored. You have an identical table in which you store French customers.
What type of calculation view should you create to combine the customers in to two columns that mirror the structure of the sources tables?
Please choose the correct answer.
Response:

Question55: Which of the following node types can you use to build a dimension view?
There are 3 correct answers to this question.
Response:

Question56: How can you optimize performance when writing SQL for use with calculation views?
There are 2 correct answers to this question.
Response:

Question57: In which programming languages can you create procedures in SAP HANA?
There are 2 correct answers to this question.
Response:

Question58: What are the features of a parent-child hierarchy?
There are 3 correct answers to this question.
Response:

Question59: A company sends out a lot of quotes. Some customers accept the quotes, and they're invoiced. The company asks you to find a list of the customers that did NOT accept the quotes.
How do you find the customers that received quotes but did NOT receive invoices?
Please choose the correct answer.

Response:

Question60: Where can you set the default value for the SAP client for the entire calculation view?
Please choose the correct answer.
Response:

Question61: You created a user-defined function with a return type of BIGINT. What type of function have you created?
Please choose the correct answer.
Response:

Question62: Why do you assign semantic types to measures or attributes in calculation views?
Please choose the correct answer.
Response:

Question63: What does SQLScript provide in SAP HANA?
There are 3 correct answers to this question.
Response:

Question64: Which text feature do you use to find sentiment in textual data?
Please choose the correct answer.
Response:

Question65: Where do you use SQLScript outside of the development environment discussed in this chapter?
There are 3 correct answers to this question.
Response:

Question66: What information can you find in the Plan Graph?
There are 2 correct answers to this question.
Response:

Question67: How does SQL Script extend SQL?
There are 3 correct answers to this question.
Response:

Question68: Which type of tables required extended storage?
Please choose the correct answer.
Response:

Question69: What is the preferred way to create a procedure?
Please choose the correct answer.
Response:

Question70: What are the two views in the Web IDE for SAP HANA?
There are 2 correct answers to this question.
Response:

Question71: Why might you use SAP HANA Graph with text analysis?
Please choose the correct answer.
Response:

Question72: Identify the principles that you need to follow during modeling.
There are 2 correct answers to this question.
Response:

Question73: Which are views of the SAP supplied virtual data model of Embedded Analytics?
There are 2 correct answers to this question.
Response:

Question74: A partitioned column table is present only in the persistent layer of an SAP HANA system Which columns and partitions are loaded into memory when the table is accessed by an application?
Please choose the correct answer.
Response:

Question75: What can you determine using the hierarchy function in a calculation view?
There are 3 correct answers to this question.
Response:

Question76: You have successfully built an SAP HANA database (HDB) module. It contains a dimension calculation view that is only consumed by one cube calculation view.
- In the dimension calculation view, you change the name of a column that is referenced by the cube calculation view.
- You then accidentally delete the design-time object of the cube calculation view.
During the build, which of the following scenarios are possible?
There are 2 correct answers to this question.
Response:

Question77: Which of the following are types of calculation view?
There are 2 correct answers to this question.
Response:

Question78: When creating a system connection in SAP HANA Studio, which of these is essential information?
There are 3 correct answers to this question.
Response:

Question79: Why do you use the query debug mode in a calculation view?
Please choose the correct answer.
Response:

Question80: Which database arteiact do you use to access external data from an XS Advanced project?
Please choose the correct answer.
Response:

Question81: Which of the following approaches can be used to implement union pruning?
There are 2 correct answers to this question.
Response:

Question82: You have assigned analytic privileges to users as shown in the diagram. What data can be viewed by the users?
There are 2 correct answers to this question.
Response:

Question83: What character is prepended to a SQLScript variable when it's used as an input variable?
Please choose the correct answer.
Response:

Question84: While converting currencies, which parameter is as important as source and target currencies?
Please choose the correct answer.
Response:

Question85: In which key areas can we expect there to be improvements when running SAP BW on SAP HANA?
There are 2 correct answers to this question.
Response:

Question86: In SAP Web IDE for SAP HANA, what can a flow graph generate in a predictive analysis scenario?
There are 2 correct answers to this question
Response:

Question87: What should you keep in mind about procedures?
There are 3 correct answers to this question.
Response:

Question88: What are features of SDA?
There are 2 correct answers to this question.
Response:

Question89: Which views in SAP S/4HANA embedded analytics may you extend?
Please choose the correct answer.
Response:

Question90: For what SQL keyword is the Aggregation node the equivalent?
Please choose the correct answer.
Response:

Question91: When do you use the hidden attribute in a dimension calculation view?
Please choose the correct answer.
Response:

Question92: What type of join should you use?
Please choose the correct answer.
Response:

Question93: You want to call a procedure in a SELECT statement (e.g., a table function). Which clauses do you have to specify?
There are 2 correct answers to this question.
Response:

Question94: Which of the following features of an XS Advanced application are provided by an HDB module?
There are 2 correct answers to this question.
Response:

Question95: You have successfully built a project you imported in the Web IDE workspace, but you cannot see the corresponding runtime database objects.
What could be the reason?
Please choose the correct answer.
Response:

Question96: Which type of data are used to represent spatial information?
There are 2 correct answers to this question.
Response:

Question97: For what type of data are SAP HANA calculation views of type dimension used?
Please choose the correct answer.
Response: